AdEnrollTerm_RebuildRelationshipLog

Logical Entity Name | AdEnrollTerm_RebuildRelationshipLog
Default Table Name | AdEnrollTerm_RebuildRelationshipLog
Physical Only | NO
Owner | dbo
Definition |
Note |

AdEnrollTerm_RebuildRelationshipLog Columns

ColumnName | Domain | Datatype | NULL | Definition
AdEnrollTerm_RebuildRelationshipLogID |  | int | NO |
RebuildDate |  | datetime | NO |
AdEnrollTermID |  | int | NO |
AdEnrollID |  | int | NO |
AdTermID |  | int | NO |
Sequence |  | numeric(4, 0) | YES |
DateBilled |  | datetime | YES |
CurGPA |  | numeric(11, 6) | YES |
CurNumAvg |  | numeric(11, 6) | YES |
CurCreditsAttempt |  | numeric(9, 2) | YES |
CurCreditsEarned |  | numeric(9, 2) | YES |
CurHoursAttempt |  | numeric(9, 2) | YES |
CurHoursEarned |  | numeric(9, 2) | YES |
CurGPAPoints |  | numeric(9, 2) | YES |
CurMinutesAttended |  | numeric(11, 2) | YES |
CurMinutesAbsent |  | numeric(9, 2) | YES |
CumGPA |  | numeric(11, 6) | YES |
CumNumAvg |  | numeric(11, 6) | YES |
CumCreditsAttempt |  | numeric(9, 2) | YES |
CumCreditsEarned |  | numeric(9, 2) | YES |
CumHoursAttempt |  | numeric(9, 2) | YES |
CumHoursEarned |  | numeric(9, 2) | YES |
CumGPAPoints |  | numeric(9, 2) | YES |
CumMinutesAttended |  | numeric(11, 2) | YES |
CumMinutesAbsent |  | numeric(9, 2) | YES |
TermCreditsSched |  | numeric(9, 2) | YES |
TermHoursSched |  | numeric(9, 2) | YES |
Comment |  | varchar(255) | YES |
SAPStatus |  | char(1) | YES |
AdAttStatID |  | int | YES |
HonorsDescrip |  | varchar(50) | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserID |  | int | NO |
AdHonorsID |  | int | YES |
AdSapStatusID |  | int | YES |
SyStudentID |  | int | YES |
CurMinutesMakeupAttended |  | int | YES |
CumMinutesMakeupAttended |  | int | YES |
CumGPACredits |  | numeric(9, 2) | YES |
StudentCurGPA |  | numeric(11, 6) | YES |
StudentCurCreditsAttempt |  | numeric(11, 2) | YES |
StudentCurHoursAttempt |  | numeric(11, 2) | YES |
StudentCurGPAPoints |  | numeric(11, 2) | YES |
StudentCumGPA |  | numeric(11, 6) | YES |
StudentCumCreditsAttempt |  | numeric(11, 2) | YES |
StudentCumHoursAttempt |  | numeric(11, 2) | YES |
StudentCumGPAPoints |  | numeric(11, 2) | YES |
BGRndSetID |  | int | NO |
GradeLevelEval |  | bit | NO |
GradeLevelEvalDate |  | datetime | YES |
TermRegCredits |  | numeric(9, 2) | YES |
TermRegHours |  | numeric(9, 2) | YES |
StudentCurCreditsEarned |  | numeric(9, 2) | YES |
StudentCurHoursEarned |  | numeric(9, 2) | YES |
StudentCumCreditsEarned |  | numeric(9, 2) | YES |
StudentCumHoursEarned |  | numeric(9, 2) | YES |

AdEnrollTerm_RebuildRelationshipLog Primary and Unique Keys

Key Name | Key Type | Keys
PK_AdEnrollTerm_RebuildRelationshipLog_AdEnrollTerm_RebuildRelationshipLogID | PrimaryKey | AdEnrollTerm_RebuildRelationshipLogID

AdEnrollTerm_RebuildRelationshipLog Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdEnroll | Non-Identifying | One To Zero or More | FK_AdEnrollTerm_RebuildRelationshipLog_AdEnrollID_AdEnroll_AdEnrollID |  |  | AdEnrollID | NO | YES
syStudent | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollTerm_RebuildRelationshipLog_SyStudentID_SyStudent_SyStudentID |  |  | SyStudentID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

AdEnrollTerm_RebuildRelationshipLog Check Constraints

Check Constraint Name | CheckConstraint

AdEnrollTerm_RebuildRelationshipLog Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | C2000_Index
Text Image File Group |

AdEnrollTerm_RebuildRelationshipLog Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentTermSummaryRebuildLog | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnrollTerm_RebuildRelationshipLog | NO |  |  |

AdEnrollTerm_RebuildRelationshipLog Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Grades/Attendance
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdEnrollTerm_RebuildRelationshipLog Data Movement Rules

Name | Type | Rule Text/Value